﻿CREATE TABLE [dim].[Contract] (
    [ContractId]       INT            IDENTITY (1, 1) NOT NULL,
    [ContractCode]     VARCHAR (16)   NOT NULL,
    [ContractName]     NVARCHAR (100) NOT NULL,
    [ContractTypeId]   INT            NOT NULL,
    [ContractTypeCode] VARCHAR (16)   NOT NULL,
    [ContractTypeName] NVARCHAR (100) NOT NULL,
    [IsInferedMember]  BIT            NOT NULL,
    [RowChecksumMD5]   CHAR (36)      NOT NULL,
    [RowAuditId]       INT            NOT NULL,
    PRIMARY KEY CLUSTERED ([ContractId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

